﻿
create view "Orders Qry" AS
SELECT Orders.OrderID, Orders.CustomerID, Orders.EmployeeID, Orders.OrderDate, Orders.RequiredDate, 
	Orders.ShippedDate, Orders.ShipVia, Orders.Freight, Orders.ShipName, Orders.ShipAddress, Orders.ShipCity, 
	Orders.ShipRegion, Orders.ShipPostalCode, Orders.ShipCountry, 
	[Clients].CompanyName, [Clients].Address, [Clients].City, [Clients].Region, [Clients].PostalCode, [Clients].Country
FROM [Clients] INNER JOIN Orders ON [Clients].CustomerID = Orders.CustomerID
